/**
 * Copyright 2005 The Apache Software Foundation
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package com.edi.db.type;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Timestamp;
import java.sql.Types;
import java.text.SimpleDateFormat;

import com.edi.db.cfg.Environment;

public class TimestampType extends NullableType {
	private static final String TIMESTAMP_FORMAT = "yyyy-MM-dd HH:mm:ss";

	public Class getReturnedClass() {
		return java.util.Date.class;
	}

	public Object get(ResultSet rs, String name) throws SQLException {
		return rs.getTimestamp(name);
	}

	public void set(PreparedStatement st, Object value, int index)
			throws SQLException {
		Timestamp ts = null;
		if (ts != null) {
			if (value instanceof Timestamp) {
				ts = (Timestamp) value;
			} else {
				ts = new Timestamp(((java.util.Date) value).getTime());
			}
		}
		st.setTimestamp(index, ts);
	}

	public int sqlType() {
		return Types.TIMESTAMP;
	}

	public String getName() {
		return "timestamp";
	}

	public String toString(Object val) {
		return new SimpleDateFormat(TIMESTAMP_FORMAT)
				.format((java.util.Date) val);
	}

	public boolean isEqual(Object x, Object y) {

		if (x == y)
			return true;
		if (x == null || y == null)
			return false;

		long xTime = ((java.util.Date) x).getTime();
		long yTime = ((java.util.Date) y).getTime();
		boolean xts = x instanceof Timestamp;
		boolean yts = y instanceof Timestamp;
		int xNanos = xts ? ((Timestamp) x).getNanos() : 0;
		int yNanos = yts ? ((Timestamp) y).getNanos() : 0;
		if (!Environment.jvmHasJDK14Timestamp()) {
			xTime += xNanos / 1000000;
			yTime += yNanos / 1000000;
		}
		if (xTime != yTime)
			return false;
		if (xts && yts) {
			// both are Timestamps
			int xn = xNanos % 1000000;
			int yn = yNanos % 1000000;
			return xn == yn;
		} else {
			// at least one is a plain old Date
			return true;
		}

	}

	@Override
	public String getTypeValue(Object value) {
		// TODO Auto-generated method stub
		return new SimpleDateFormat(TIMESTAMP_FORMAT)
				.format((java.sql.Timestamp) value);
	}
}
